#ifndef SQLTOOL_H
#define SQLTOOL_H

#include <QString>
#include <QStringList>
#include <QVariantList>

class SqlTool
{
public:
    static QString SQL_INSERT_ROW(QString strTableName, QVariantList varListRowVal);
    static QString SQL_DELETE(QString strTableName,  QString strColName,QString strVal);
    static QString SQL_UPDATE_ROW(QString strTableName,
                                  QStringList strListColName, QVariantList varListColVal);
    static QString SQL_UPDATE_COLUMN(QString strTableName, QString strIndexColName,QString strIndexVal,
                                     QString strColName,QString strVal);
    static QString SQL_QUERY(QString strTableName,QString strColName,QString strVal);
    static QString SQL_QUERY_ALL(QString strTableName);
    static QString SQL_CREATE_TABLE(QString strTableName,QStringList strListColName);
    static QString SQL_DROP_TABLE(QString strTableName);
    static QString SQL_EXIST_TABLE(QString strTableName);
};

#endif // SQLTOOL_H
